package com.dmtt.web.mapper;

import com.dmtt.web.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ActivationMapper {
    List<Activation> findActivationSingle(@Param("agvName") String agvName,@Param("startTime") String startTime,@Param("endTime") String endTime);

    List<ChangeGrain> faultChangeGrainSingle(@Param("agvName") String agvName, @Param("startTime") String startTime, @Param("endTime") String endTime);


    List<Activation> faultAccumulationSingle(@Param("startTime") String startTime, @Param("endTime") String endTime);

    List<Activation> faultPassingMonth(@Param("agvName") String agvName,@Param("startTime") String startTime,@Param("endTime") String endTime);

    List<Activation> faultPassingSingle(@Param("startTime") String startTime, @Param("endTime") String endTime);

    List<MovemontRate> findMovemontSingle(@Param("startTime") String startTime,@Param("endTime") String endTime);


    List<AgcStatistics> AgcStatistic( @Param("startTime") String startTime, @Param("endTime") String endTime ,
                                      @Param("agvName") String agvName);

    List<AgcAverage> agcAverage();

    List<AgcAverage> agcAverageMonths();


    List<Activation> findActivationMonth1(@Param("agvName") String agvName, @Param("startTime") String startTime,
                                          @Param("endTime") String endTime, @Param("total") Integer total);

    List<Activation> findActivationMonth2(@Param("agvName") String agvName, @Param("time") String time,
                                          @Param("total") Integer total);

    List<MovemontRate> findMovemontMonth1(@Param("agvName") String agvName, @Param("startTime") String startTime,
                                          @Param("endTime") String endTime,@Param("total") Integer total);

    List<MovemontRate> findMovemontMonth2(@Param("agvName") String agvName, @Param("time") String time,
                                          @Param("total") Integer total);

    List<ChangeGrain> faultChangeGrainMonth1(@Param("agvName") String agvName, @Param("startTime") String startTime,
                                             @Param("endTime") String endTime,@Param("total") Integer total);

    List<ChangeGrain> faultChangeGrainMonth2(@Param(("agvName")) String agvName, @Param("time") String time,
                                             @Param("total") Integer total);

    List<Activation> faultAccumulationMonth1(@Param("agvName") String agvName, @Param("startTime") String startTime,
                                             @Param("endTime") String endTime,@Param("total") Integer total);

    List<Activation> faultAccumulationMonth2(@Param("agvName") String agvName, @Param("time") String time,
                                             @Param("total") Integer total);

    List<AgvList> carList();

    int intAgv(@Param("agvName") String agvName);

    List<AgcAverage> AgcStatistic1(@Param("startTime") String startTime,@Param("endTime") String endTime);

    List<AgcAverage> AgcStatistic2(@Param("startTime") String startTime,@Param("endTime") String endTime, @Param("agvName") String agvName);

    YearCalendar findYear(@Param("s") String s);

    void saveYearCalendar(@Param("s") String s);

    List<String> yearList();

    void deleteYear(@Param("s") String s);
}
